/************************************************************************************
* SLDataRetriever.hs                                                                 *
*                                                                                   *
* Copyright (C) 2011 Varuna L Amachi                                                *
*                                                                                   *
* This program is free software; you can redistribute it and/or modify              *
* it under the terms of the GNU General Public License as published by              *
* the Free Software Foundation; either version 2 of the License, or any             *
* later version.                                                                    *
*                                                                                   *
* This program is distributed in the hope that it will be useful, but               *
* WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY        *
* or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for       *
* more details. You should have received a copy of the GNU General Public           *
* License along with this program; if not, write to the Free Software Foundation,   *
* Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA                       *
*                                                                                   *
*************************************************************************************/

#ifndef SLDATARETRIEVER_H
#define SLDATARETRIEVER_H

#include "interfaces/IDbRetriever.h"


class SLDataRetriever : public IDbRetriever
{
    CollectorItem* getCollectorItemFromQuery(QSqlQuery *query);

    inline QSqlQuery* getQuery(QSqlDatabase *database);
public:
    SLDataRetriever();

    QHash<QString, CollectorItem*>* retrieveCollection(QSqlDatabase *database = NULL);
    QList<QString>* retrieveRecentlyAdded(QSqlDatabase *database = NULL);
    quint64 retrievePlayedTime(QString &trackId, QSqlDatabase *databse = NULL);
    QList<QString>* retrieveHistory(QSqlDatabase *database = NULL);
    quint64 retrieveAddedTime(QString &trackId, QSqlDatabase *databse = NULL);
    QList<SavedPlaylist*>* retrievePlaylists(QSqlDatabase *database = NULL);
    QHash<QString, QVariant>* retrieveSettings(QSqlDatabase *database = NULL);

    QList<QString>* retrieveTrackIdsForPlaylist(QString playlistName,
                                                        QSqlDatabase *database = NULL);

    MediaRating getRatingFor(QString trackId, QSqlDatabase *database = NULL);
    int getPlayCountFor(QString trackId, QSqlDatabase *database = NULL);
};

#endif // SLDATARETRIEVER_H
